package cn.yuanqiao.archive.Identify.mapper;/**
 * @author 赵常飞
 * @date 2023/7/10 10:25
 */

import cn.yuanqiao.archive.Identify.domain.*;
import cn.yuanqiao.archive.appManager.domain.DataScopeBase;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 *
 *@AUTHOR:赵常飞
 *@date 2023/7/10 10:25
 */
public interface IsOpenIdentifyMapper {
    public List<Map<String, Object>> getlist(@Param("dataScopeBase") DataScopeBase dataScopeBase, @Param("fields") String fields, @Param("tablename") String tablename, @Param("bgqxgqsql") String bgqxgqsql, @Param("lczsql") String lczsql, @Param("tiaojian") String tiaojian, @Param("orderstr") String orderstr, @Param("orderfield") String orderfield);

    int createKfjdJobTable(@Param("tableName") String tableName);

    int createKfjdJobDaTable(@Param("tableName") String tableName);

    int createKfjdTask(@Param("tableName")String tableName);

    int createKfjdFolderDaTable(@Param("tableName") String tableName);

    int createKfjdItemFolderTable(@Param("tableName") String tableName);

    List<Map<String, Object>> kfjdjoblist(@Param("title")String title,@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("state") Integer state,@Param("qzh") String qzh,@Param("tableName") String tableName,@Param("order")String order);

    List<Map<String, Object>> kfjdjoblistnew(@Param("title")String title,@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("state") Integer state,@Param("qzh") String qzh,@Param("tableName") String tableName,@Param("order")String order);

    int addjob(TenantYqKfjdJob kfjdJob);

    int createJdFileTable(@Param("tableName")String tableName);

    void addfile(TenantYqJdFile yqJdFile);

    Map<String, Object> getjobinfo(TenantYqKfjdJob YqKfjdJob);

    List<Map<String, Object>> getfileinfo(@Param("YqJdFile")TenantYqJdFile YqJdFile,@Param("mjWhere")String mjWhere);

    int deletefile(TenantYqJdFile yqJdFile);

    TenantYqJdFile getfilebyid(TenantYqJdFile yqJdFile);

    int updatejobinfo(TenantYqKfjdJob yqKfjdJob);

    int insertda(TenantYqKfjdJobDa yqKfjdJobDa);

    int insertfolderda(TenantYqKfjdFolderDa yqKfjdFolderDa);

    int insertitemfolder(TenantYqKfjdItemFolder yqKfjdItemFolder);

    List<TenantYqKfjdJobDa> getyqKfjdJobDabyrenwuid(@Param("renwuid")Long renwuid,@Param("tableName") String tableName);

    void deletejobDa(@Param("renwuid")Long renwuid,@Param("ids")List ids,@Param("tableName") String tableName);

    void deletefolderda(@Param("renwuid")Long renwuid,@Param("ids") List ids,@Param("tableName") String tableName);

    String getfolderidsbyxm(@Param("renwuid")Long renwuid,@Param("ids") List ids,@Param("tableName") String tableName);

    void deletefolderda1(@Param("renwuid")Long renwuid,@Param("folderids") String folderids,@Param("tableName") String tableName);

    void deleteitemfolder(@Param("renwuid")Long renwuid,@Param("ids") List ids,@Param("tableName") String tableName);

    List<Map<String, Object>> getdatalistbyrenwuid(@Param("renwuid")Long renwuid,@Param("searchtable") String searchtable,@Param("fields") String fields,@Param("tiaojian") String tiaojian,@Param("tableName")String tableName,@Param("order")String  order);

    List<Map<String, Integer>> getcsfsallnumbyrenwuid(@Param("renwuid")Long renwuid,@Param("tableName") String tableName);

    Map<String, Object> getinfonumperson(@Param("renwuid")Long renwuid,@Param("tableName") String tableName,@Param("datableName")String datableName);

    List<Map<String, Object>> cspjfplist(@Param("renwuid")Long renwuid,@Param("index")int index,@Param("usersize") int usersize,@Param("subTableName") String sub_table_name,@Param("tableName") String tableName,@Param("tiaojian")String tiaojian,@Param("fields")String fields,@Param("order")String order);

    int pingjunfenpeirenwu(@Param("tableName")String tableName, @Param("statefield")String statefield,@Param("personfield") String personfield,@Param("userid") String userid,@Param("renwuid") Long renwuid,@Param("index") int index,@Param("usersize") int usersize);

    int markfp(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("ids") List ids,@Param("markfield") String markfield,@Param("checked") int checked);

    List<Map<String, Object>> sdfplist(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("personfield") String personfield,@Param("subTableName")String subTableName,@Param("fields") String fields,@Param("tiaojian") String tiaojian,@Param("order") String order);

    int commitsdfp(@Param("tableName")String tableName, @Param("renwuid")Long renwuid,@Param("userid") Long userid,@Param("statefield") String statefield, @Param("personfield")String personfield,@Param("ids") List ids);

    int refp(@Param("tableName")String tableName,@Param("statefield") String statefield,@Param("personfield") String personfield,@Param("renwuid") Long renwuid);

    int gethasjobbyuser(@Param("olduser")Long olduser,@Param("renwuid") Long renwuid, @Param("tableName")String tableName,@Param("personfield") String personfield);

    int tzry(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("personfield") String personfield,@Param("userlist") String userlist);

    int addtask(TenantYqKfjdTask task);

    int updatetask(TenantYqKfjdTask task);

    List<Map<String, Object>> gettaskinfo(@Param("renwuid")Long renwuid,@Param("tableName") String tableName,@Param("dicttableName") String dicttableName);

    List<Map<String, Object>> gettablenameandtypebyid(@Param("renwuid") Long renwuid,@Param("datableName") String datableName,@Param("jobtableName") String jobtableName);

    Map<String, Object> getjianinfo(@Param("subTableName")String subTableName,@Param("daid") String daid);

    int updatetitle(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("id") Long id,@Param("newtitle")String newtitle);

    Map<String, Object> getcateinfo(@Param("tableName")String tableName,@Param("subTableName") String subTableName,@Param("type") String type);

    List<Map<String, Object>> getjnjinfobyfolderif(@Param("fileTableName")String fileTableName,@Param("relatableName") String relatableName,@Param("folderid") String folderid);

    List<Map<String, Object>> getjuaninfobyfolderif(@Param("folderTableMame")String folderTableMame, @Param("relatableName") String relatableName,@Param("itemid") String itemid);

    List<Map<String, Object>> getchushenjob(@Param("datableName")String datableName,@Param("jobtableName")String jobtableName,@Param("catetableName")String catetableName,@Param("userid") Long userid);

    Map<String, Object> getchushennum(@Param("renwuid")Long renwuid,@Param("tableName") String tableName,@Param("userid") Long userid);

    List<Map<String, Object>> cssplist(@Param("jobtableName")String jobtableName,@Param("subTableName") String subTableName,@Param("renwuid") Long renwuid,@Param("userid") Long userid,@Param("tiaojian") String tiaojian,@Param("orderStr") String orderStr,@Param("jdstate") String jdstate,@Param("fields")String fields);

    int getspnum(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("jiandingfield") String jiandingfield,@Param("daids") List daids);

    int chushentijiao(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("tijiaofield") String tijiaofield,@Param("daids") List daids);

    int updatetaskcaozuoren(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("state") int state,@Param("userid") Long userid);

    int gettijiaonum(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("tijiaofield") String tijiaofield);

    int getnofushenpersonnum(@Param("tableName")String tableName,@Param("renwuid") Long renwuid);

    int updateshending(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("daid") Long daid,@Param("jiandingfield") String jiandingfield,@Param("jiandingstate") String jiandingstate,@Param("jdvalue") String jdvalue);

    int updateshendingnew(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("daid") Long daid,
                          @Param("jiandingfield") String jiandingfield,@Param("jiandingstate") String jiandingstate,
                          @Param("jdvalue") String jdvalue , @Param("chuzhifangsshi") String chuzhifangsshi,
                          @Param("fsvale") String fsvale ,@Param("state") String state);

    int getjiandingnum(@Param("tableName")String tableName,@Param("renwuid") Long renwuid, @Param("daid")Long daid,@Param("jiandingstate") String jiandingstate);

    int getkznum(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("jiandingfield")String jiandingfield,@Param("daid") Long daid);

    int updateliyou(@Param("tableName")String tableName,@Param("liyoufield") String liyoufield,@Param("lyvalue") String lyvalue,@Param("renwuid") Long renwuid,@Param("daid") Long daid);

    List<Map<String, Object>> getdetaillist(@Param("datatableName")String fileTableName,@Param ("jdtableName")String tableName,@Param ("daid") Long daid,@Param ("renwuid") Long renwuid,@Param ("fields")String fields,@Param ("tiaojian")String tiaojian ,@Param ("orderstr")String orderstr,@Param("daTableName")String daTableName);

    List<Map<String, Object>> getfushenjob(@Param("datableName")String datableName,@Param("jobtableName")String jobtableName,@Param("catetableName")String catetableName,@Param("userid") Long userid);

    Map<String, Object> getfushennum(@Param("renwuid")Long renwuid,@Param("tableName") String tableName,@Param("userid") Long userid);

    List<Map<String, Object>> fssplist(@Param("jobtableName")String jobtableName,@Param("subTableName") String subTableName,@Param("renwuid") Long renwuid,@Param("userid") Long userid,@Param("tiaojian") String tiaojian,@Param("orderStr") String orderStr,@Param("jdstate") String jdstate,@Param("fields")String fields);

    int choucha(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("daid") Long daid);

    List<Map<String, Object>> sdlist(@Param("jobdatableName")String jobdatableName,@Param("subTableName") String subTableName,@Param("renwuid") Long renwuid,@Param("userid") Long userid,@Param("tiaojian") String tiaojian,@Param("orderStr") String orderStr,@Param("fields")String fields,@Param("jobtableName")String jobtableName);

    List<Map<String, Object>> getsdjoblist(@Param("datableName")String datableName,@Param("jobtableName")String jobtableName,@Param("catetableName")String catetableName,@Param("userid") Long userid);

    int updatedatable(TenantYqKfjdJobDa yqKfjdJobDa);

    List<Map<String, Object>> getstateanduser(@Param("tableName")String tableName,@Param("jobids") List jobids);

    int updateresult(@Param("maintableName")String maintableName, @Param("mainfield")String mainfield,@Param("subTableName") String subTableName, @Param("subfield")String subfield,@Param("idsql") String idsql,@Param("jobdatable")String jobdatable,@Param("renwuid")String renwuid,@Param("nowdate")String nowdate);

    int jiandingagin(@Param("maintableName")String maintableName, @Param("mainfield")String mainfield,@Param("subTableName") String subTableName, @Param("subfield")String subfield,@Param("idsql") String idsql);

    List<Map<String, Object>> gettongjibyjobname(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable);

    Map<String, Object> getuser(@Param("field")String field,@Param("tableName") String tableName);

    List<Map<String, Object>> gettongjibyuserchushen(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable,@Param("userid")String userid);

    List<Map<String, Object>> gettongjibyuserfushen(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable,@Param("userid")String userid);

    List<Map<String, Object>> gettongjibycate(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable);

    List<Map<String, Object>> gettongjibyqzh(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable);

    List<Map<String, Object>> kfjdjoblist1(@Param("tableName")String tableName,@Param("sysdatatable") String sysdatatable,@Param("ids")List ids);

    List<Map<String, Object>> getexportckdata(@Param("tableName")String tableName,@Param("idsql") String idsql);

    List<Map<String, Object>> exportjobdadata(@Param("renwuid")Long renwuid,@Param("tableName")String tableName, @Param("searchtable")String searchtable, @Param("fields")String fields,@Param("orderstr") String orderstr,@Param("ids") List ids,@Param("dicttable")String dicttable);

    int getnofpcsnum(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("field") String field);

    Map getdainfo(@Param("tableName")String tableName, @Param("renwuid")Long renwuid,@Param("daid") Long daid);

    int shendingtijiao(TenantYqKfjdJobDa yqKfjdJobDa);

    int updatefolderda(TenantYqKfjdFolderDa folderDa);

    int shendingtijiaofolderda(TenantYqKfjdFolderDa folderDa);

    List<Map<String, Object>> getlistfromcz(@Param("fields") String fields,@Param("tablename") String tablename,@Param("bgqxgqsql") String bgqxgqsql,@Param("lczsql") String lczsql,@Param("tiaojian") String tiaojian,@Param("orderstr") String orderstr);

    int updatedatable1(TenantYqKfjdJobDa jobDa);

    int updatefolderda1(TenantYqKfjdFolderDa folderDa);

    Map<String, Object> getuserbyrenwuid(@Param("fields")String field,@Param("tableName") String tableName,@Param("renwuid")Long renwuid);

    Map<String, Object> getchouchanum(@Param("renwuid")Long renwuid, @Param("userid")Long userid, @Param("tableName")String tableName, @Param("datableName")String datableName,@Param("folderdatableName")String folderdatableName,@Param("kzbl") Double kzbl, @Param("kfbl")Double kfbl,@Param("sub")String sub);

    List<String> getmdatalist(@Param("categoryId")long categoryId,@Param("type") int type,@Param("tableName") String tableName,@Param("catetable") String catetable);

    int selectjobByRenwuno(@Param("tableName") String tableName, @Param("renwuno")String renwuno);

    List<String> selectFileIdByFolderId(@Param("folderId") String folderId, @Param("tableName") String tableName);

    int editcate(@Param("tableName")String tableName,@Param("renwuid") Long renwuid);

    int getdanum(@Param("tableName")String tableName,@Param("id") Long id);

    List<String> selectString(@Param("field") String field, @Param("sql") String sql);

    List<Map<String, Object>> getdictdata(@Param("fieldName")String fieldName,@Param("tableName") String tableName);
}
